Filename: rates.csv
This file describes the available rates for all customers in this company and the available prices per billing period. If a single rate is allowed to be billed monthly and yearly then it should show up twice with the same name, but with the corresponding period and price (1 month is a period of 1, and the corresponding price for that particular period).
Columns used to specify the number of a particular service type allowed are optional, and if the column is not included in the import then it is assumed that service type is not allowed for any rate. This does not prevent a service from being added on import, but prevents the service from being added after the customer is in the billing system.
Column Name | Description | ||
---|---|---|
name | Name of the rate. This should be unique per period, but the same for a rate with multiple billing periods | |
period | Billing period for the rate, in months | |
price | recurring amount charged per billing period | |
emails_allowed | (optional) Number of email services allowed on this rate | |
domains_allowed | (optional) Number of domain services allowed on this rate | |
dialup_allowed | (optional) Number of dialup services allowed on this rate | |
webhosting_allowed | (optional) Number of webhosting services allowed on this rate | |
slipstream_allowed | (optional) Number of slipstream services allowed on this rate | |
staticip_allowed | (optional) Number of static ip services allowed on this rate |
An example import with 1 rate with 2 available periods is:
name, period, price
A Rate, 1, 10
A Rate, 12, 120
The available rateis named “A Rate” and can be billed every month at $10 a month, or billed yearly (every 12 months) at $120 per year.